package com.ruoyi.system.mapper;

import com.ruoyi.common.core.domain.entity.GarbageRecordDetail;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author: ruohao
 * @Date: 2023/9/3
 **/
public interface GarbageRecordDetailMapper {
    public List<GarbageRecordDetail> selectList(GarbageRecordDetail garbageRecordDetail);

    public List<GarbageRecordDetail> selectAll(GarbageRecordDetail garbageRecordDetail);

    public List<GarbageRecordDetail> selectToday(GarbageRecordDetail garbageRecordDetail);

    public GarbageRecordDetail selectById(Long id);

    public List<GarbageRecordDetail> selectByRecordId(Long id);

    public int insert(GarbageRecordDetail garbageRecordDetail);

    public int update(GarbageRecordDetail garbageRecordDetail);

    public int deleteById(Long id);

    public int deleteByIds(List<Long> ids);

    Integer selectSumByLocationAndTime(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("garbageTypeId") Long garbageTypeId,
                                       @Param("location") String location);
}
